/*
 Navicat Premium Data Transfer

 Source Server         : Poker
 Source Server Type    : MySQL
 Source Server Version : 50648
 Source Host           : 137.116.140.36:3306
 Source Schema         : game_19mob_mobi

 Target Server Type    : MySQL
 Target Server Version : 50648
 File Encoding         : 65001

 Date: 26/07/2020 15:42:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for p_action_log
-- ----------------------------
DROP TABLE IF EXISTS `p_action_log`;
CREATE TABLE `p_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `log` longtext NOT NULL COMMENT '日志备注',
  `log_url` varchar(255) NOT NULL COMMENT '执行的URL',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  `username` varchar(255) NOT NULL COMMENT '执行者',
  `title` varchar(255) NOT NULL COMMENT '标题',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=205 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

-- ----------------------------
-- Records of p_action_log
-- ----------------------------
BEGIN;
INSERT INTO `p_action_log` VALUES (14, 1, 3085058158, '管理员[ 测试 ]更新了系统管理=>系统设置=>常规设置', '/publics/system/general.html', 1592236897, '测试', '更新数据');
INSERT INTO `p_action_log` VALUES (15, 1, 1971854261, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1592458050, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (16, 1, 30363434, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593352072, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (17, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 150575 ]的信息', '/publics/user/edit.html', 1593359098, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (18, 1, 3085058506, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593361075, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (19, 1, 3085058506, '管理员[ 测试 ]编辑了会员[ 150577 ]的信息', '/publics/user/edit.html', 1593363507, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (20, 1, 3085058506, '管理员[ 测试 ]编辑了会员[ 150576 ]的信息', '/publics/user/edit.html', 1593363615, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (21, 1, 1991610802, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593364127, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (22, 1, 1991610802, '管理员[ 测试 ]编辑了会员[ 150578 ]的信息', '/publics/user/edit.html', 1593364141, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (23, 1, 1991610802, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1593364620, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (24, 1, 1991610802, '管理员[ 测试 ]更新了系统管理=>系统设置=>常规设置', '/publics/system/general.html', 1593369993, '测试', '更新数据');
INSERT INTO `p_action_log` VALUES (25, 1, 1991610802, '管理员[ 测试 ]更新了系统管理=>系统设置=>常规设置', '/publics/system/general.html', 1593369998, '测试', '更新数据');
INSERT INTO `p_action_log` VALUES (26, 1, 30363434, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593396794, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (27, 1, 1971871606, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593403025, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (28, 1, 30363775, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593503428, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (29, 1, 30363775, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593566344, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (30, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593567388, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (31, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1593568420, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (32, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593568998, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (33, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1593569943, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (34, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1593570380, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (35, 1, 30363775, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593579957, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (36, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1593580774, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (37, 1, 30363775, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1593581385, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (38, 1, 30363775, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593594968, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (39, 1, 795083455, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593613497, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (40, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1593613515, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (41, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1593614825, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (42, 1, 795083455, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593664735, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (43, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1593664747, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (44, 1, 1971854170, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593667912, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (45, 1, 1971854170, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1593667929, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (46, 1, 1971854170, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1593668199, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (47, 1, 1971854170, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1593670018, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (48, 1, 30364500, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593680027, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (49, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593763267, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (50, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593765697, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (51, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593768371, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (52, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1593768451, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (53, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1593769100, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (54, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593769161, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (55, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1593769209, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (56, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593825437, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (57, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593825471, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (58, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1593825676, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (59, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593833560, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (60, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1593833578, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (61, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593833596, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (62, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1593833614, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (63, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593834362, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (64, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593842913, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (65, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1593842961, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (66, 1, 795083455, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593844201, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (67, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1593845260, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (68, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1593845357, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (69, 1, 30363587, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1593845384, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (70, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1593853499, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (71, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150580 ]的信息', '/publics/user/edit.html', 1593853507, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (72, 1, 30363587, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1593857175, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (73, 1, 795083455, '管理员[ 测试 ]更新了系统管理=>系统设置=>常规设置', '/publics/system/general.html', 1593870608, '测试', '更新数据');
INSERT INTO `p_action_log` VALUES (74, 1, 30364791, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594001366, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (75, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1594001412, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (76, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150583 ]的信息', '/publics/user/edit.html', 1594001428, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (77, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594001610, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (78, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594001627, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (79, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594001735, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (80, 1, 30364791, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594026781, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (81, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594026827, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (82, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594026895, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (83, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1594027362, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (84, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1594027696, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (85, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1594027737, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (86, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1594027737, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (87, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1594028157, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (88, 1, 30364791, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594028301, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (89, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150575 ]的信息', '/publics/user/edit.html', 1594028452, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (90, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150575 ]的信息', '/publics/user/edit.html', 1594028464, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (91, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150579 ]的信息', '/publics/user/edit.html', 1594028631, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (92, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594028928, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (93, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 196026 ]的信息', '/publics/user/edit.html', 1594028936, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (94, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150575 ]的信息', '/publics/user/edit.html', 1594028944, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (95, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594028985, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (96, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150576 ]的信息', '/publics/user/edit.html', 1594029284, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (97, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150582 ]的信息', '/publics/user/edit.html', 1594029846, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (98, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150581 ]的信息', '/publics/user/edit.html', 1594030042, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (99, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150584 ]的信息', '/publics/user/edit.html', 1594030373, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (100, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150586 ]的信息', '/publics/user/edit.html', 1594030460, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (101, 1, 30364791, '管理员[ 测试 ]编辑了会员[ 150585 ]的信息', '/publics/user/edit.html', 1594030470, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (102, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594048971, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (103, 1, 30364322, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594086685, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (104, 1, 1975286595, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594096416, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (105, 1, 30364322, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594102652, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (106, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150588 ]的信息', '/publics/user/edit.html', 1594102671, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (107, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150587 ]的信息', '/publics/user/edit.html', 1594102681, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (108, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150588 ]的信息', '/publics/user/edit.html', 1594102706, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (109, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150587 ]的信息', '/publics/user/edit.html', 1594102716, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (110, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594102729, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (111, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594103662, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (112, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150587 ]的信息', '/publics/user/edit.html', 1594108836, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (113, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150589 ]的信息', '/publics/user/edit.html', 1594109447, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (114, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594109456, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (115, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150589 ]的信息', '/publics/user/edit.html', 1594114023, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (116, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150589 ]的信息', '/publics/user/edit.html', 1594114023, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (117, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114383, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (118, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114383, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (119, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114383, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (120, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114388, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (121, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114388, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (122, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 196025 ]的信息', '/publics/user/edit.html', 1594114388, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (123, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114718, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (124, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114718, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (125, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114718, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (126, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114718, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (127, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114718, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (128, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (129, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (130, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (131, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (132, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (133, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (134, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114784, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (135, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (136, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (137, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (138, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (139, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (140, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (141, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594114792, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (142, 1, 795083455, '管理员[ 测试 ]编辑了会员[ 196024 ]的信息', '/publics/user/edit.html', 1594115756, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (143, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150599 ]的信息', '/publics/user/edit.html', 1594117571, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (144, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594117727, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (145, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150601 ]的信息', '/publics/user/edit.html', 1594118141, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (146, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150602 ]的信息', '/publics/user/edit.html', 1594120881, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (147, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150603 ]的信息', '/publics/user/edit.html', 1594121135, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (148, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150602 ]的信息', '/publics/user/edit.html', 1594121288, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (149, 1, 30364322, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594189664, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (150, 1, 3748141370, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594191847, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (151, 1, 1785467995, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594191939, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (152, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594200668, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (153, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594200687, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (154, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594200909, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (155, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594200941, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (156, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594200965, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (157, 1, 30364322, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594201097, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (158, 1, 30364254, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594257714, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (159, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150605 ]的信息', '/publics/user/edit.html', 1594258172, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (160, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150599 ]的信息', '/publics/user/edit.html', 1594258224, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (161, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150601 ]的信息', '/publics/user/edit.html', 1594258625, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (162, 1, 30364254, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594259829, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (163, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150601 ]的信息', '/publics/user/edit.html', 1594262608, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (164, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594262618, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (165, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150599 ]的信息', '/publics/user/edit.html', 1594262626, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (166, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594262637, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (167, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594262657, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (168, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150603 ]的信息', '/publics/user/edit.html', 1594271867, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (169, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150602 ]的信息', '/publics/user/edit.html', 1594279673, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (170, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150606 ]的信息', '/publics/user/edit.html', 1594279883, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (171, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150607 ]的信息', '/publics/user/edit.html', 1594280078, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (172, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150606 ]的信息', '/publics/user/edit.html', 1594288623, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (173, 1, 30364254, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594344690, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (174, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346538, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (175, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346601, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (176, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346640, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (177, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346665, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (178, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346895, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (179, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594346969, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (180, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347024, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (181, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347046, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (182, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347165, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (183, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347208, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (184, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347234, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (185, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347297, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (186, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594347997, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (187, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594348114, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (188, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594348160, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (189, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594348212, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (190, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594348427, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (191, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150604 ]的信息', '/publics/user/edit.html', 1594348709, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (192, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594348720, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (193, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150601 ]的信息', '/publics/user/edit.html', 1594348953, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (194, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594348960, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (195, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150601 ]的信息', '/publics/user/edit.html', 1594351498, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (196, 1, 30364254, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594351508, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (197, 1, 30364972, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594429574, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (198, 1, 30364972, '管理员[ 测试 ]编辑了会员[ 150600 ]的信息', '/publics/user/edit.html', 1594430307, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (199, 1, 30364972, '管理员[ 测试 ] 更新房间状态 [ 21 ]正常', '/publics/room/edit/id/21.html', 1594446526, '测试', '正常');
INSERT INTO `p_action_log` VALUES (200, 1, 30364972, '管理员[ 测试 ] 更新房间状态 [ 21 ]关闭', '/publics/room/edit/id/21.html', 1594446562, '测试', '关闭');
INSERT INTO `p_action_log` VALUES (201, 1, 30364972, '管理员[ 测试 ]编辑了会员[ 150603 ]的信息', '/publics/user/edit.html', 1594458230, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (202, 1, 30363051, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594618265, '测试', '后台登录');
INSERT INTO `p_action_log` VALUES (203, 1, 30363051, '管理员[ 测试 ]编辑了会员[ 150608 ]的信息', '/publics/user/edit.html', 1594637142, '测试', '会员编辑');
INSERT INTO `p_action_log` VALUES (204, 1, 30363339, '管理员[ 测试 ]偷偷的进入后台了', '/publics/login/index.html', 1594868447, '测试', '后台登录');
COMMIT;

-- ----------------------------
-- Table structure for p_admin
-- ----------------------------
DROP TABLE IF EXISTS `p_admin`;
CREATE TABLE `p_admin` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `login_user` varchar(16) NOT NULL COMMENT '登录账号',
  `login_pass` varchar(32) NOT NULL COMMENT '登录密码',
  `username` varchar(16) NOT NULL COMMENT '用户名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户状态 0-正常 1-冻结',
  `user_email` varchar(32) DEFAULT NULL COMMENT '用户邮箱',
  `last_login_ip` varchar(16) DEFAULT NULL COMMENT '最后一次登录ip',
  `last_login_time` int(16) DEFAULT NULL COMMENT '最后一次登录时间',
  `create_time` int(16) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(16) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`,`login_user`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
-- Records of p_admin
-- ----------------------------
BEGIN;
INSERT INTO `p_admin` VALUES (1, 'q25979', 'e10adc3949ba59abbe56e057f20f883e', '测试', 0, NULL, '1.207.78.203', 1594868447, NULL, 1594868447);
INSERT INTO `p_admin` VALUES (2, 'tz131419', 'f34161b7bfe9f9b5161566991d51e604', 'AC', 0, NULL, '183.226.64.110', 1592126666, 1592041104, 1593364043);
COMMIT;

-- ----------------------------
-- Table structure for p_auth_access
-- ----------------------------
DROP TABLE IF EXISTS `p_auth_access`;
CREATE TABLE `p_auth_access` (
  `role_id` mediumint(8) unsigned NOT NULL COMMENT '角色',
  `rule_name` varchar(255) NOT NULL COMMENT '规则唯一英文标识,全小写',
  `type` varchar(30) DEFAULT NULL COMMENT '权限规则分类，请加应用前缀,如admin_',
  `menu_id` int(11) DEFAULT NULL COMMENT '后台菜单ID',
  KEY `role_id` (`role_id`),
  KEY `rule_name` (`rule_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权表';

-- ----------------------------
-- Records of p_auth_access
-- ----------------------------
BEGIN;
INSERT INTO `p_auth_access` VALUES (2, 'publics/index/index', 'admin_url', 1);
INSERT INTO `p_auth_access` VALUES (2, 'publics/index/home', 'admin_url', 19);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/general', 'admin_url', 15);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/general', 'admin_url', 27);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/general', 'admin_url', 50);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/the_loan', 'admin_url', 57);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/sms_api', 'admin_url', 58);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/log', 'admin_url', 33);
INSERT INTO `p_auth_access` VALUES (2, 'publics/system/clearlog', 'admin_url', 34);
INSERT INTO `p_auth_access` VALUES (2, 'publics/user/index', 'admin_url', 28);
INSERT INTO `p_auth_access` VALUES (2, 'publics/user/index', 'admin_url', 29);
INSERT INTO `p_auth_access` VALUES (2, 'publics/user/record', 'admin_url', 59);
INSERT INTO `p_auth_access` VALUES (2, 'publics/user/message', 'admin_url', 60);
INSERT INTO `p_auth_access` VALUES (2, 'publics/finance/index', 'admin_url', 51);
INSERT INTO `p_auth_access` VALUES (2, 'publics/finance/recharge', 'admin_url', 52);
INSERT INTO `p_auth_access` VALUES (2, 'publics/finance/withdrawal', 'admin_url', 53);
INSERT INTO `p_auth_access` VALUES (2, 'publics/finance/alow', 'admin_url', 54);
INSERT INTO `p_auth_access` VALUES (2, 'publics/room/index', 'admin_url', 55);
INSERT INTO `p_auth_access` VALUES (2, 'publics/room/index', 'admin_url', 56);
INSERT INTO `p_auth_access` VALUES (2, 'publics/table/index', 'admin_url', 61);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/default', 'admin_url', 2);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/role', 'admin_url', 3);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/roleadd', 'admin_url', 4);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/roleedit', 'admin_url', 5);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/roledelete', 'admin_url', 6);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/authorize', 'admin_url', 7);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/index', 'admin_url', 14);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/add', 'admin_url', 21);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/edit', 'admin_url', 22);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/status', 'admin_url', 23);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/deleted', 'admin_url', 24);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/adminauthorize', 'admin_url', 25);
INSERT INTO `p_auth_access` VALUES (2, 'publics/admin/update_pass', 'admin_url', 26);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/default', 'admin_url', 8);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/menu', 'admin_url', 9);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/menuadd', 'admin_url', 10);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/menuedit', 'admin_url', 11);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/menudelete', 'admin_url', 12);
INSERT INTO `p_auth_access` VALUES (2, 'publics/auth/menuorder', 'admin_url', 13);
COMMIT;

-- ----------------------------
-- Table structure for p_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `p_auth_role`;
CREATE TABLE `p_auth_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '角色名称',
  `pid` smallint(6) DEFAULT '0' COMMENT '父角色ID',
  `status` tinyint(1) unsigned DEFAULT NULL COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorder` int(3) NOT NULL DEFAULT '0' COMMENT '排序字段',
  PRIMARY KEY (`id`),
  KEY `parentId` (`pid`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of p_auth_role
-- ----------------------------
BEGIN;
INSERT INTO `p_auth_role` VALUES (1, '超级管理员', 0, 1, '拥有网站最高管理员权限！', 1329633709, 1329633709, 0);
INSERT INTO `p_auth_role` VALUES (2, '客服管理', 0, 1, '', 0, 1584772116, 0);
COMMIT;

-- ----------------------------
-- Table structure for p_auth_role_user
-- ----------------------------
DROP TABLE IF EXISTS `p_auth_role_user`;
CREATE TABLE `p_auth_role_user` (
  `role_id` int(11) unsigned DEFAULT '0' COMMENT '角色 id',
  `user_id` int(11) DEFAULT '0' COMMENT '用户id',
  KEY `group_id` (`role_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户角色对应表';

-- ----------------------------
-- Records of p_auth_role_user
-- ----------------------------
BEGIN;
INSERT INTO `p_auth_role_user` VALUES (2, 22);
INSERT INTO `p_auth_role_user` VALUES (1, 2);
COMMIT;

-- ----------------------------
-- Table structure for p_config
-- ----------------------------
DROP TABLE IF EXISTS `p_config`;
CREATE TABLE `p_config` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `name` varchar(50) NOT NULL COMMENT '配置名称',
  `value` text NOT NULL COMMENT '变量',
  `inc_type` varchar(64) DEFAULT NULL COMMENT '类型',
  `desc` varchar(16) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`,`name`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='配置表';

-- ----------------------------
-- Records of p_config
-- ----------------------------
BEGIN;
INSERT INTO `p_config` VALUES (1, 'create_table_amount', '3', 'create', '创建牌桌消费砖石');
INSERT INTO `p_config` VALUES (2, 'kf_intercept', '0', 'general', '常规设置');
INSERT INTO `p_config` VALUES (3, 'site_code', '', 'general', '常规设置');
INSERT INTO `p_config` VALUES (4, 'wxcode', '/uploads/site/20200704/ef3254950b90cd9ff2900c4ff48c3fb8.png', 'general', '常规设置');
INSERT INTO `p_config` VALUES (5, 'wxzh', 'ceshi', 'general', '常规设置');
INSERT INTO `p_config` VALUES (6, 'zfbcode', '/uploads/site/20200704/806b3917cef1ef7326de1b8d55cc51b6.png', 'general', '常规设置');
INSERT INTO `p_config` VALUES (7, 'zfbzh', 'ceshi', 'general', '常规设置');
INSERT INTO `p_config` VALUES (8, 'bank_name', 'ceshi', 'general', '常规设置');
INSERT INTO `p_config` VALUES (9, 'bank_account', '6227115122154515', 'general', '常规设置');
INSERT INTO `p_config` VALUES (10, 'bank_people', '测试不要', 'general', '常规设置');
INSERT INTO `p_config` VALUES (11, 'wxkf', 'q25454545', 'general', '常规设置');
INSERT INTO `p_config` VALUES (12, 'qqkf', 'ww5x5x45', 'general', '常规设置');
COMMIT;

-- ----------------------------
-- Table structure for p_menu
-- ----------------------------
DROP TABLE IF EXISTS `p_menu`;
CREATE TABLE `p_menu` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `parent_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `app` char(20) NOT NULL COMMENT '应用名称app',
  `model` char(20) NOT NULL COMMENT '控制器',
  `action` char(20) NOT NULL COMMENT '操作名称',
  `url_param` char(50) DEFAULT NULL COMMENT 'url参数',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '菜单类型  1：权限认证+菜单；0：只作为菜单',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，1显示，0不显示',
  `name` varchar(50) NOT NULL COMMENT '菜单名称',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `list_order` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序ID',
  `rule_param` varchar(255) DEFAULT NULL COMMENT '验证规则',
  `nav_id` int(11) DEFAULT '0' COMMENT 'nav ID ',
  `request` varchar(255) DEFAULT NULL COMMENT '请求方式（日志生成）',
  `log_rule` varchar(255) DEFAULT NULL COMMENT '日志规则',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `model` (`model`),
  KEY `parent_id` (`parent_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';

-- ----------------------------
-- Records of p_menu
-- ----------------------------
BEGIN;
INSERT INTO `p_menu` VALUES (1, 0, 'publics', 'index', 'index', '', 1, 1, '全部系统', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (2, 1, 'publics', 'auth', 'default', '', 1, 1, '权限管理', 'layui-icon-component', '', 998, '', 0, '', '');
INSERT INTO `p_menu` VALUES (3, 2, 'publics', 'auth', 'role', '', 1, 1, '角色管理', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (4, 3, 'publics', 'auth', 'roleAdd', '', 1, 0, '角色增加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (5, 3, 'publics', 'auth', 'roleEdit', '', 1, 0, '角色编辑', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (6, 3, 'publics', 'auth', 'roleDelete', '', 0, 0, '角色删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (7, 3, 'publics', 'auth', 'authorize', '', 0, 0, '权限设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (8, 1, 'publics', 'auth', 'default', '', 1, 1, '菜单管理', 'layui-icon-cols', '', 999, '', 0, '', '');
INSERT INTO `p_menu` VALUES (9, 8, 'publics', 'auth', 'menu', '', 1, 1, '菜单列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (10, 9, 'publics', 'auth', 'menuAdd', '', 1, 0, '菜单增加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (11, 9, 'publics', 'auth', 'menuEdit', '', 0, 0, '菜单修改', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (12, 9, 'publics', 'auth', 'menuDelete', '', 1, 0, '菜单删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (13, 9, 'publics', 'auth', 'menuOrder', '', 1, 0, '菜单排序', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (14, 2, 'publics', 'admin', 'index', '', 1, 1, '管理员管理', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (15, 1, 'publics', 'system', 'general', '', 1, 1, '系统管理', 'layui-icon-home', '', 1, '', 0, '', '');
INSERT INTO `p_menu` VALUES (19, 1, 'publics', 'index', 'home', '', 1, 0, '系统主页', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (21, 14, 'publics', 'admin', 'add', '', 0, 0, '用户添加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (22, 14, 'publics', 'admin', 'edit', '', 1, 0, '用户编辑', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (23, 14, 'publics', 'admin', 'status', '', 1, 0, '用户状态', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (24, 14, 'publics', 'admin', 'deleted', '', 1, 0, '用户删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (25, 14, 'publics', 'auth', 'adminAuthorize', '', 0, 0, '查看权限', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (26, 14, 'publics', 'admin', 'update_pass', '', 1, 0, '密码修改', '', '', 0, '', 0, 'POST', '');
INSERT INTO `p_menu` VALUES (27, 15, 'publics', 'system', 'general', '', 1, 1, '系统设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (28, 1, 'publics', 'user', 'index', '', 1, 1, '用户管理', 'layui-icon-user', '', 2, '', 0, '', '');
INSERT INTO `p_menu` VALUES (29, 28, 'publics', 'user', 'index', '', 1, 1, '用户列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (33, 15, 'publics', 'system', 'log', '', 0, 1, '管理员日志', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (34, 33, 'publics', 'system', 'clearlog', '', 0, 0, '清空日志', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (50, 27, 'publics', 'system', 'general', '', 0, 0, '常规设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (51, 1, 'publics', 'finance', 'index', '', 1, 1, '资金管理', 'layui-icon-rmb', '', 3, '', 0, '', '');
INSERT INTO `p_menu` VALUES (52, 51, 'publics', 'finance', 'recharge', '', 1, 1, '充值记录', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (53, 51, 'publics', 'finance', 'withdrawal', '', 0, 1, '提现记录', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (54, 51, 'publics', 'finance', 'alow', '', 1, 0, '还款列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (55, 1, 'publics', 'room', 'index', '', 1, 1, '房间管理', 'layui-icon-read', '', 4, '', 0, '', '');
INSERT INTO `p_menu` VALUES (56, 55, 'publics', 'room', 'index', '', 1, 1, '房间列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (57, 27, 'publics', 'system', 'the_loan', '', 0, 0, '贷款设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (58, 27, 'publics', 'system', 'sms_api', '', 1, 0, '接口设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (59, 28, 'publics', 'user', 'record', '', 1, 1, '用户战绩', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (60, 28, 'publics', 'user', 'message', '', 1, 1, '用户消息', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu` VALUES (61, 55, 'publics', 'table', 'index', '', 1, 1, '桌子列表', '', '', 0, '', 0, '', '');
COMMIT;

-- ----------------------------
-- Table structure for p_menu_copy1
-- ----------------------------
DROP TABLE IF EXISTS `p_menu_copy1`;
CREATE TABLE `p_menu_copy1` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `parent_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `app` char(20) NOT NULL COMMENT '应用名称app',
  `model` char(20) NOT NULL COMMENT '控制器',
  `action` char(20) NOT NULL COMMENT '操作名称',
  `url_param` char(50) DEFAULT NULL COMMENT 'url参数',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '菜单类型  1：权限认证+菜单；0：只作为菜单',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，1显示，0不显示',
  `name` varchar(50) NOT NULL COMMENT '菜单名称',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `list_order` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序ID',
  `rule_param` varchar(255) DEFAULT NULL COMMENT '验证规则',
  `nav_id` int(11) DEFAULT '0' COMMENT 'nav ID ',
  `request` varchar(255) DEFAULT NULL COMMENT '请求方式（日志生成）',
  `log_rule` varchar(255) DEFAULT NULL COMMENT '日志规则',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `model` (`model`),
  KEY `parent_id` (`parent_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';

-- ----------------------------
-- Records of p_menu_copy1
-- ----------------------------
BEGIN;
INSERT INTO `p_menu_copy1` VALUES (1, 0, 'publics', 'index', 'index', '', 1, 1, '全部系统', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (2, 1, 'publics', 'auth', 'default', '', 1, 1, '权限管理', 'layui-icon-component', '', 998, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (3, 2, 'publics', 'auth', 'role', '', 1, 1, '角色管理', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (4, 3, 'publics', 'auth', 'roleAdd', '', 1, 0, '角色增加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (5, 3, 'publics', 'auth', 'roleEdit', '', 1, 0, '角色编辑', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (6, 3, 'publics', 'auth', 'roleDelete', '', 0, 0, '角色删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (7, 3, 'publics', 'auth', 'authorize', '', 0, 0, '权限设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (8, 1, 'publics', 'auth', 'default', '', 1, 1, '菜单管理', 'layui-icon-cols', '', 999, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (9, 8, 'publics', 'auth', 'menu', '', 1, 1, '菜单列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (10, 9, 'publics', 'auth', 'menuAdd', '', 1, 0, '菜单增加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (11, 9, 'publics', 'auth', 'menuEdit', '', 0, 0, '菜单修改', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (12, 9, 'publics', 'auth', 'menuDelete', '', 1, 0, '菜单删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (13, 9, 'publics', 'auth', 'menuOrder', '', 1, 0, '菜单排序', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (14, 2, 'publics', 'admin', 'index', '', 1, 1, '管理员管理', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (15, 1, 'publics', 'system', 'general', '', 1, 1, '系统管理', 'layui-icon-home', '', 1, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (19, 1, 'publics', 'index', 'home', '', 1, 0, '系统主页', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (21, 14, 'publics', 'admin', 'add', '', 0, 0, '用户添加', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (22, 14, 'publics', 'admin', 'edit', '', 1, 0, '用户编辑', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (23, 14, 'publics', 'admin', 'status', '', 1, 0, '用户状态', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (24, 14, 'publics', 'admin', 'deleted', '', 1, 0, '用户删除', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (25, 14, 'publics', 'auth', 'adminAuthorize', '', 0, 0, '查看权限', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (26, 14, 'publics', 'admin', 'update_pass', '', 1, 0, '密码修改', '', '', 0, '', 0, 'POST', '');
INSERT INTO `p_menu_copy1` VALUES (27, 15, 'publics', 'system', 'general', '', 1, 1, '系统设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (28, 1, 'publics', 'user', 'index', '', 1, 1, '会员管理', 'layui-icon-user', '', 2, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (29, 28, 'publics', 'user', 'index', '', 1, 1, '会员列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (52, 51, 'publics', 'finance', 'borrowing', '', 1, 1, '借款列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (51, 1, 'publics', 'finance', 'index', '', 1, 0, '资金管理', 'layui-icon-rmb', '', 3, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (33, 15, 'publics', 'system', 'log', '', 0, 1, '管理员日志', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (34, 33, 'publics', 'system', 'clearlog', '', 0, 0, '清空日志', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (58, 27, 'publics', 'system', 'sms_api', '', 1, 0, '接口设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (57, 27, 'publics', 'system', 'the_loan', '', 0, 0, '贷款设置', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (54, 51, 'publics', 'finance', 'alow', '', 1, 0, '还款列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (53, 51, 'publics', 'finance', 'withdrawal', '', 1, 0, '提现列表', '', '', 0, '', 0, '', '');
INSERT INTO `p_menu_copy1` VALUES (50, 27, 'publics', 'system', 'general', '', 0, 0, '常规设置', '', '', 0, '', 0, '', '');
COMMIT;

-- ----------------------------
-- Table structure for p_user
-- ----------------------------
DROP TABLE IF EXISTS `p_user`;
CREATE TABLE `p_user` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '用户自增id',
  `uid` varchar(6) NOT NULL COMMENT '用户id 6位随机数',
  `phone` varchar(11) NOT NULL COMMENT '手机号(登录账号)',
  `password` varchar(32) NOT NULL COMMENT '登录密码 md5(明文+创建时间)',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '账号类型 0-普通账号 1-透视 2-好牌 3-全部功能',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '账号状态 0-正常 1-冻结',
  `username` varchar(6) DEFAULT NULL COMMENT '昵称',
  `headimg` tinyint(4) NOT NULL DEFAULT '1' COMMENT '头像id',
  `balance` int(9) NOT NULL DEFAULT '0' COMMENT '砖石个数',
  `register_ip` varchar(15) NOT NULL DEFAULT '无' COMMENT '注册ip',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '无' COMMENT '最后一次登录ip',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '软删除',
  PRIMARY KEY (`id`,`phone`,`uid`) USING BTREE,
  UNIQUE KEY `id` (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`) USING BTREE,
  UNIQUE KEY `phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of p_user
-- ----------------------------
BEGIN;
INSERT INTO `p_user` VALUES (28, '150599', '18954232111', 'b4d1f688ac06f761cdaef861884e1e08', 0, 0, '测试账号1', 2, 3002, '1.207.82.162', '1.207.85.44', 1594117551, 1594460685, NULL);
INSERT INTO `p_user` VALUES (29, '150600', '18954232222', '1eeea6ce00453d1187e74333d65f7062', 0, 0, '测试账号2', 4, 2997, '1.207.82.162', '1.207.77.171', 1594117713, 1594618471, NULL);
INSERT INTO `p_user` VALUES (30, '150601', '18954232333', '4a4c6543e4d2e6fa576b79767123b81c', 0, 0, '测试账号3', 2, 12320, '1.207.82.162', '1.207.77.171', 1594118122, 1594626999, NULL);
INSERT INTO `p_user` VALUES (31, '150602', '15160062278', '8841bd1b026be7958fe1fbbb378bd581', 0, 0, '田', 1, 97272, '183.229.17.118', '1.207.82.94', 1594120630, 1594288403, NULL);
INSERT INTO `p_user` VALUES (32, '150603', '13211344181', '6c6a4f0cfca6a54219dae6b9a7f8a28a', 0, 0, '133132', 1, 10972, '1.207.82.162', '1.207.82.94', 1594121104, 1594458230, NULL);
INSERT INTO `p_user` VALUES (33, '150604', '15111111111', '3e2b9e4a6c1c20e7f841ea8ed9f939c6', 0, 0, '啊啊啊啊啊啊', 5, 46031, '1.207.82.162', '1.207.77.171', 1594200633, 1594618335, NULL);
INSERT INTO `p_user` VALUES (34, '150605', '15222222222', '739497297848850aed1299bd28541594', 0, 0, '测试账号4', 4, 2997, '1.207.82.94', '1.207.82.94', 1594258158, 1594261413, NULL);
INSERT INTO `p_user` VALUES (35, '150606', '15333333333', 'b4ec96e25aa4d8260e7b996cf92e5ecb', 0, 0, '测试账号5', 1, 2987, '1.207.82.94', '1.207.82.94', 1594279868, 1594288623, NULL);
INSERT INTO `p_user` VALUES (36, '150607', '15444444444', '3f65d528de429099df530c23f606ba1a', 0, 0, '测试账号6', 1, 8992, '1.207.82.94', '1.207.82.94', 1594280062, 1594286194, NULL);
INSERT INTO `p_user` VALUES (37, '150608', '13885578651', 'f1b2a200155913d2dcbe830aad050bff', 0, 0, '路由器', 7, 3000, '218.67.102.122', '106.43.196.4', 1594625358, 1594815411, NULL);
INSERT INTO `p_user` VALUES (38, '150609', '18580997790', '24e4db0a68ed07a6977abd823d3b2ee5', 0, 0, '波', 4, 0, '27.12.19.209', '123.147.248.146', 1594815321, 1594873818, NULL);
INSERT INTO `p_user` VALUES (39, '150610', '15158556452', '0b7df04d1f73e7282451865596f6c3ab', 0, 0, '181598', 5, 0, '106.43.196.4', '106.43.196.4', 1594815436, 1594815436, NULL);
COMMIT;

-- ----------------------------
-- Table structure for p_user_fund_log
-- ----------------------------
DROP TABLE IF EXISTS `p_user_fund_log`;
CREATE TABLE `p_user_fund_log` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` varchar(6) NOT NULL COMMENT '用户id',
  `order_no` varchar(24) NOT NULL COMMENT '订单号',
  `deal_type` varchar(4) NOT NULL COMMENT '交易类型-后台定义',
  `deal_before` int(9) NOT NULL COMMENT '交易之前砖石',
  `deal_amount` int(9) NOT NULL COMMENT '交易砖石',
  `deal_after` int(9) NOT NULL COMMENT '交易之后砖石',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态 0-未审核 1-审核通过 2-拒绝审核',
  `remake` varchar(128) DEFAULT NULL COMMENT '备注',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`,`order_no`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  UNIQUE KEY `order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='用户资金表';

-- ----------------------------
-- Table structure for p_user_grade
-- ----------------------------
DROP TABLE IF EXISTS `p_user_grade`;
CREATE TABLE `p_user_grade` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `tid` int(12) NOT NULL COMMENT '桌子id',
  `uid` varchar(6) NOT NULL COMMENT '用户id',
  `innings` int(3) NOT NULL DEFAULT '1' COMMENT '局数(进行的第几局)',
  `win` int(9) NOT NULL DEFAULT '0' COMMENT '赢多少砖石(可为负数，负数为输)',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8mb4 COMMENT='用户战绩表';

-- ----------------------------
-- Records of p_user_grade
-- ----------------------------
BEGIN;
INSERT INTO `p_user_grade` VALUES (99, 276352, '150603', 1, 9994, 1594121258);
INSERT INTO `p_user_grade` VALUES (100, 276352, '150602', 1, -9994, 1594121258);
INSERT INTO `p_user_grade` VALUES (101, 276353, '150602', 1, 180, 1594121467);
INSERT INTO `p_user_grade` VALUES (102, 276353, '150603', 1, -180, 1594121467);
INSERT INTO `p_user_grade` VALUES (103, 276353, '150602', 2, -150, 1594121567);
INSERT INTO `p_user_grade` VALUES (104, 276353, '150603', 2, 150, 1594121567);
INSERT INTO `p_user_grade` VALUES (105, 276353, '150602', 3, 250, 1594121736);
INSERT INTO `p_user_grade` VALUES (106, 276353, '150603', 3, -250, 1594121736);
INSERT INTO `p_user_grade` VALUES (107, 276355, '150599', 1, 12, 1594190509);
INSERT INTO `p_user_grade` VALUES (108, 276355, '150600', 1, -12, 1594190509);
INSERT INTO `p_user_grade` VALUES (109, 276357, '150607', 1, 6015, 1594288579);
INSERT INTO `p_user_grade` VALUES (110, 276357, '150602', 1, -3000, 1594288579);
INSERT INTO `p_user_grade` VALUES (111, 276357, '150606', 1, -3000, 1594288579);
INSERT INTO `p_user_grade` VALUES (112, 276357, '150603', 1, -15, 1594288579);
INSERT INTO `p_user_grade` VALUES (113, 276357, '150603', 2, 19, 1594288681);
INSERT INTO `p_user_grade` VALUES (114, 276357, '150607', 2, -9, 1594288681);
INSERT INTO `p_user_grade` VALUES (115, 276357, '150606', 2, -7, 1594288681);
INSERT INTO `p_user_grade` VALUES (116, 276357, '150602', 2, -3, 1594288681);
INSERT INTO `p_user_grade` VALUES (117, 276357, '150603', 3, 19, 1594288776);
INSERT INTO `p_user_grade` VALUES (118, 276357, '150607', 3, -8, 1594288776);
INSERT INTO `p_user_grade` VALUES (119, 276357, '150606', 3, -3, 1594288776);
INSERT INTO `p_user_grade` VALUES (120, 276357, '150602', 3, -8, 1594288776);
INSERT INTO `p_user_grade` VALUES (121, 276358, '150603', 1, -3, 1594288926);
INSERT INTO `p_user_grade` VALUES (122, 276358, '150602', 1, 6, 1594288926);
INSERT INTO `p_user_grade` VALUES (123, 276358, '150606', 1, -3, 1594288926);
INSERT INTO `p_user_grade` VALUES (124, 276358, '150603', 2, -1, 1594288942);
INSERT INTO `p_user_grade` VALUES (125, 276358, '150602', 2, -1, 1594288942);
INSERT INTO `p_user_grade` VALUES (126, 276358, '150606', 2, 2, 1594288942);
INSERT INTO `p_user_grade` VALUES (127, 276358, '150606', 3, -1, 1594288956);
INSERT INTO `p_user_grade` VALUES (128, 276358, '150603', 3, -1, 1594288956);
INSERT INTO `p_user_grade` VALUES (129, 276358, '150602', 3, 2, 1594288956);
INSERT INTO `p_user_grade` VALUES (130, 276358, '150606', 4, -1, 1594288967);
INSERT INTO `p_user_grade` VALUES (131, 276358, '150602', 4, -1, 1594288967);
INSERT INTO `p_user_grade` VALUES (132, 276358, '150603', 4, 2, 1594288967);
INSERT INTO `p_user_grade` VALUES (133, 276361, '150604', 1, 3000, 1594346500);
INSERT INTO `p_user_grade` VALUES (134, 276361, '150600', 1, -3000, 1594346500);
INSERT INTO `p_user_grade` VALUES (135, 276361, '150604', 2, 3000, 1594346581);
INSERT INTO `p_user_grade` VALUES (136, 276361, '150600', 2, -3000, 1594346581);
INSERT INTO `p_user_grade` VALUES (137, 276361, '150604', 3, 3000, 1594346630);
INSERT INTO `p_user_grade` VALUES (138, 276361, '150600', 3, -3000, 1594346630);
INSERT INTO `p_user_grade` VALUES (139, 276361, '150604', 4, 3000, 1594346655);
INSERT INTO `p_user_grade` VALUES (140, 276361, '150600', 4, -3000, 1594346655);
INSERT INTO `p_user_grade` VALUES (141, 276362, '150604', 1, 3000, 1594346880);
INSERT INTO `p_user_grade` VALUES (142, 276362, '150600', 1, -3000, 1594346880);
INSERT INTO `p_user_grade` VALUES (143, 276362, '150604', 2, 3000, 1594346909);
INSERT INTO `p_user_grade` VALUES (144, 276362, '150600', 2, -3000, 1594346909);
INSERT INTO `p_user_grade` VALUES (145, 276362, '150604', 3, 3000, 1594347007);
INSERT INTO `p_user_grade` VALUES (146, 276362, '150600', 3, -3000, 1594347007);
INSERT INTO `p_user_grade` VALUES (147, 276362, '150604', 4, 30, 1594347038);
INSERT INTO `p_user_grade` VALUES (148, 276362, '150600', 4, -30, 1594347038);
INSERT INTO `p_user_grade` VALUES (149, 276362, '150604', 5, 30, 1594347062);
INSERT INTO `p_user_grade` VALUES (150, 276362, '150600', 5, -30, 1594347062);
INSERT INTO `p_user_grade` VALUES (151, 276362, '150604', 6, 30, 1594347204);
INSERT INTO `p_user_grade` VALUES (152, 276362, '150600', 6, -30, 1594347204);
INSERT INTO `p_user_grade` VALUES (153, 276362, '150604', 7, 30, 1594347221);
INSERT INTO `p_user_grade` VALUES (154, 276362, '150600', 7, -30, 1594347221);
INSERT INTO `p_user_grade` VALUES (155, 276362, '150604', 8, 30, 1594347292);
INSERT INTO `p_user_grade` VALUES (156, 276362, '150600', 8, -30, 1594347292);
INSERT INTO `p_user_grade` VALUES (157, 276363, '150600', 1, 27, 1594347367);
INSERT INTO `p_user_grade` VALUES (158, 276363, '150604', 1, -27, 1594347367);
INSERT INTO `p_user_grade` VALUES (159, 276363, '150600', 2, 54, 1594347488);
INSERT INTO `p_user_grade` VALUES (160, 276363, '150604', 2, -54, 1594347488);
INSERT INTO `p_user_grade` VALUES (161, 276363, '150600', 3, 108, 1594347536);
INSERT INTO `p_user_grade` VALUES (162, 276363, '150604', 3, -108, 1594347536);
INSERT INTO `p_user_grade` VALUES (163, 276363, '150600', 4, 216, 1594347557);
INSERT INTO `p_user_grade` VALUES (164, 276363, '150604', 4, -216, 1594347557);
INSERT INTO `p_user_grade` VALUES (165, 276363, '150600', 5, 432, 1594347585);
INSERT INTO `p_user_grade` VALUES (166, 276363, '150604', 5, -432, 1594347585);
INSERT INTO `p_user_grade` VALUES (167, 276363, '150600', 6, 864, 1594347601);
INSERT INTO `p_user_grade` VALUES (168, 276363, '150604', 6, -864, 1594347601);
INSERT INTO `p_user_grade` VALUES (169, 276363, '150600', 7, 1728, 1594347642);
INSERT INTO `p_user_grade` VALUES (170, 276363, '150604', 7, -1728, 1594347642);
INSERT INTO `p_user_grade` VALUES (171, 276363, '150600', 8, 3456, 1594347654);
INSERT INTO `p_user_grade` VALUES (172, 276363, '150604', 8, -3456, 1594347654);
INSERT INTO `p_user_grade` VALUES (173, 276364, '150600', 1, 6909, 1594347703);
INSERT INTO `p_user_grade` VALUES (174, 276364, '150604', 1, -6909, 1594347703);
INSERT INTO `p_user_grade` VALUES (175, 276364, '150600', 2, 13818, 1594347713);
INSERT INTO `p_user_grade` VALUES (176, 276364, '150604', 2, -13818, 1594347713);
INSERT INTO `p_user_grade` VALUES (177, 276364, '150600', 3, 27636, 1594347723);
INSERT INTO `p_user_grade` VALUES (178, 276364, '150604', 3, -27636, 1594347723);
INSERT INTO `p_user_grade` VALUES (179, 276364, '150600', 4, 55272, 1594347752);
INSERT INTO `p_user_grade` VALUES (180, 276364, '150604', 4, -55272, 1594347752);
INSERT INTO `p_user_grade` VALUES (181, 276364, '150600', 5, 110544, 1594347760);
INSERT INTO `p_user_grade` VALUES (182, 276364, '150604', 5, -110544, 1594347760);
INSERT INTO `p_user_grade` VALUES (183, 276364, '150600', 6, 221088, 1594347769);
INSERT INTO `p_user_grade` VALUES (184, 276364, '150604', 6, -221088, 1594347769);
INSERT INTO `p_user_grade` VALUES (185, 276364, '150600', 7, 442176, 1594347783);
INSERT INTO `p_user_grade` VALUES (186, 276364, '150604', 7, -442176, 1594347783);
INSERT INTO `p_user_grade` VALUES (187, 276364, '150600', 8, 884352, 1594347818);
INSERT INTO `p_user_grade` VALUES (188, 276364, '150604', 8, -884352, 1594347818);
INSERT INTO `p_user_grade` VALUES (189, 276365, '150604', 1, 1768704, 1594347960);
INSERT INTO `p_user_grade` VALUES (190, 276365, '150600', 1, -1768704, 1594347960);
INSERT INTO `p_user_grade` VALUES (191, 276366, '150600', 1, 1234564, 1594348050);
INSERT INTO `p_user_grade` VALUES (192, 276366, '150604', 1, -1234564, 1594348050);
INSERT INTO `p_user_grade` VALUES (193, 276366, '150604', 2, 2469128, 1594348076);
INSERT INTO `p_user_grade` VALUES (194, 276366, '150600', 2, -2469128, 1594348076);
INSERT INTO `p_user_grade` VALUES (195, 276366, '150604', 3, 123456789, 1594348133);
INSERT INTO `p_user_grade` VALUES (196, 276366, '150600', 3, -123456789, 1594348133);
INSERT INTO `p_user_grade` VALUES (197, 276366, '150604', 4, 123456789, 1594348205);
INSERT INTO `p_user_grade` VALUES (198, 276366, '150600', 4, -123456789, 1594348205);
INSERT INTO `p_user_grade` VALUES (199, 276367, '150600', 1, 123456786, 1594348263);
INSERT INTO `p_user_grade` VALUES (200, 276367, '150604', 1, -123456786, 1594348263);
INSERT INTO `p_user_grade` VALUES (201, 276367, '150600', 2, 246913572, 1594348293);
INSERT INTO `p_user_grade` VALUES (202, 276367, '150604', 2, -246913572, 1594348293);
INSERT INTO `p_user_grade` VALUES (203, 276367, '150600', 3, 493827144, 1594348318);
INSERT INTO `p_user_grade` VALUES (204, 276367, '150604', 3, -493827144, 1594348318);
INSERT INTO `p_user_grade` VALUES (205, 276367, '150600', 4, 987654288, 1594348345);
INSERT INTO `p_user_grade` VALUES (206, 276367, '150604', 4, -987654288, 1594348345);
INSERT INTO `p_user_grade` VALUES (207, 276367, '150600', 5, 295631857, 1594348400);
INSERT INTO `p_user_grade` VALUES (208, 276367, '150604', 5, -295631857, 1594348400);
INSERT INTO `p_user_grade` VALUES (209, 276365, '150604', 2, 123456789, 1594348461);
INSERT INTO `p_user_grade` VALUES (210, 276365, '150600', 2, -123456789, 1594348461);
INSERT INTO `p_user_grade` VALUES (211, 276365, '150604', 3, 15345, 1594348933);
INSERT INTO `p_user_grade` VALUES (212, 276365, '150600', 3, -12345, 1594348933);
INSERT INTO `p_user_grade` VALUES (213, 276365, '150601', 3, -3000, 1594348933);
INSERT INTO `p_user_grade` VALUES (214, 276365, '150604', 4, 6000, 1594348982);
INSERT INTO `p_user_grade` VALUES (215, 276365, '150600', 4, -3000, 1594348982);
INSERT INTO `p_user_grade` VALUES (216, 276365, '150601', 4, -3000, 1594348982);
INSERT INTO `p_user_grade` VALUES (217, 276370, '150604', 1, 12, 1594358813);
INSERT INTO `p_user_grade` VALUES (218, 276370, '150600', 1, -12, 1594358813);
INSERT INTO `p_user_grade` VALUES (219, 276370, '150600', 2, 12330, 1594359160);
INSERT INTO `p_user_grade` VALUES (220, 276370, '150604', 2, -12330, 1594359160);
INSERT INTO `p_user_grade` VALUES (221, 276367, '150600', 6, 8, 1594360060);
INSERT INTO `p_user_grade` VALUES (222, 276367, '150604', 6, -8, 1594360060);
INSERT INTO `p_user_grade` VALUES (223, 276367, '150604', 7, 10, 1594360560);
INSERT INTO `p_user_grade` VALUES (224, 276367, '150601', 7, -5, 1594360560);
INSERT INTO `p_user_grade` VALUES (225, 276367, '150600', 7, -5, 1594360560);
INSERT INTO `p_user_grade` VALUES (226, 276370, '150600', 3, -1, 1594364783);
INSERT INTO `p_user_grade` VALUES (227, 276370, '150604', 3, 1, 1594364783);
INSERT INTO `p_user_grade` VALUES (228, 276370, '150600', 4, 3, 1594364830);
INSERT INTO `p_user_grade` VALUES (229, 276370, '150604', 4, -3, 1594364830);
INSERT INTO `p_user_grade` VALUES (230, 276370, '150604', 5, 6, 1594364863);
INSERT INTO `p_user_grade` VALUES (231, 276370, '150600', 5, -6, 1594364863);
INSERT INTO `p_user_grade` VALUES (232, 276370, '150604', 6, 21372, 1594364880);
INSERT INTO `p_user_grade` VALUES (233, 276370, '150600', 6, -21372, 1594364880);
INSERT INTO `p_user_grade` VALUES (234, 276370, '150604', 7, -1, 1594364971);
INSERT INTO `p_user_grade` VALUES (235, 276370, '150600', 7, 1, 1594364971);
INSERT INTO `p_user_grade` VALUES (236, 276370, '150600', 8, -1, 1594364980);
INSERT INTO `p_user_grade` VALUES (237, 276370, '150604', 8, 1, 1594364981);
INSERT INTO `p_user_grade` VALUES (238, 276370, '150600', 9, 21, 1594365027);
INSERT INTO `p_user_grade` VALUES (239, 276370, '150604', 9, -21, 1594365027);
INSERT INTO `p_user_grade` VALUES (240, 276370, '150604', 10, 3308, 1594374469);
INSERT INTO `p_user_grade` VALUES (241, 276370, '150600', 10, -3308, 1594374469);
INSERT INTO `p_user_grade` VALUES (242, 276371, '150601', 1, -6, 1594376653);
INSERT INTO `p_user_grade` VALUES (243, 276371, '150604', 1, 6, 1594376653);
INSERT INTO `p_user_grade` VALUES (244, 276372, '150601', 1, -2, 1594377038);
INSERT INTO `p_user_grade` VALUES (245, 276372, '150599', 1, 2, 1594377038);
COMMIT;

-- ----------------------------
-- Table structure for p_user_msg
-- ----------------------------
DROP TABLE IF EXISTS `p_user_msg`;
CREATE TABLE `p_user_msg` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` varchar(6) NOT NULL COMMENT '用户id',
  `msg` varchar(255) NOT NULL COMMENT '消息内容',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `is_unread` tinyint(1) NOT NULL DEFAULT '1' COMMENT '未读邮件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COMMENT='用户消息表';

-- ----------------------------
-- Records of p_user_msg
-- ----------------------------
BEGIN;
INSERT INTO `p_user_msg` VALUES (176, '150602', '创建牌桌扣除3颗砖石', 1594120907, 1);
INSERT INTO `p_user_msg` VALUES (177, '150602', '创建牌桌扣除3颗砖石', 1594121151, 1);
INSERT INTO `p_user_msg` VALUES (179, '150602', '创建牌桌扣除3颗砖石', 1594121357, 1);
INSERT INTO `p_user_msg` VALUES (183, '150603', '创建牌桌扣除3颗砖石', 1594280398, 1);
INSERT INTO `p_user_msg` VALUES (184, '150603', '创建牌桌扣除3颗砖石', 1594280428, 1);
INSERT INTO `p_user_msg` VALUES (197, '150604', '创建牌桌扣除3颗砖石', 1594374949, 1);
INSERT INTO `p_user_msg` VALUES (199, '150601', '创建牌桌扣除3颗砖石', 1594460981, 1);
INSERT INTO `p_user_msg` VALUES (200, '150601', '创建牌桌扣除3颗砖石', 1594461011, 1);
INSERT INTO `p_user_msg` VALUES (201, '150604', '创建牌桌扣除3颗砖石', 1594618332, 1);
INSERT INTO `p_user_msg` VALUES (203, '150601', '创建牌桌扣除3颗砖石', 1594627031, 1);
COMMIT;

-- ----------------------------
-- Table structure for p_user_room
-- ----------------------------
DROP TABLE IF EXISTS `p_user_room`;
CREATE TABLE `p_user_room` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `rid` varchar(6) NOT NULL COMMENT '房间号-6位随机数',
  `uid` varchar(6) NOT NULL COMMENT '用户id',
  `name` varchar(8) NOT NULL COMMENT '房间名',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '房间状态 0-正常 1-关闭',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`,`rid`,`uid`,`name`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  UNIQUE KEY `rid` (`rid`) USING BTREE,
  UNIQUE KEY `uid` (`uid`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='用户房间';

-- ----------------------------
-- Records of p_user_room
-- ----------------------------
BEGIN;
INSERT INTO `p_user_room` VALUES (14, '348509', '150599', '测试联盟1', 0, 1594189937, 1594189937, NULL);
INSERT INTO `p_user_room` VALUES (15, '348510', '150607', '测试联盟2', 0, 1594280109, 1594280109, NULL);
INSERT INTO `p_user_room` VALUES (16, '348511', '150606', '测试联盟3', 0, 1594280236, 1594280236, NULL);
INSERT INTO `p_user_room` VALUES (17, '348512', '150602', '测试联盟4', 0, 1594280291, 1594280291, NULL);
INSERT INTO `p_user_room` VALUES (18, '348513', '150603', '测试联盟5', 0, 1594280354, 1594280354, NULL);
INSERT INTO `p_user_room` VALUES (22, '348517', '150601', '断网联盟', 0, 1594461727, 1594461727, NULL);
COMMIT;

-- ----------------------------
-- Table structure for p_user_room_table
-- ----------------------------
DROP TABLE IF EXISTS `p_user_room_table`;
CREATE TABLE `p_user_room_table` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `rid` varchar(6) NOT NULL COMMENT '房间id',
  `uid` varchar(6) NOT NULL COMMENT '创建的用户id(创建者)',
  `min_balance` int(9) NOT NULL DEFAULT '0' COMMENT '最低进入房间余额',
  `number` int(1) NOT NULL DEFAULT '0' COMMENT '房间人数',
  `is_send_text` tinyint(1) NOT NULL DEFAULT '1' COMMENT '发送文字 1-可以 0-不可以',
  `is_send_voice` tinyint(1) NOT NULL COMMENT '发送语音 1-可以 0-不可以',
  `low_grade` int(9) NOT NULL COMMENT '低分(下注低砖)',
  `innings` int(3) NOT NULL DEFAULT '6' COMMENT '桌子局数(到这个局数之后自动回收)',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=276378 DEFAULT CHARSET=utf8mb4 COMMENT='用户房间的桌子';

-- ----------------------------
-- Records of p_user_room_table
-- ----------------------------
BEGIN;
INSERT INTO `p_user_room_table` VALUES (276349, '348507', '150599', 1, 2, 1, 0, 1, 4, 1594117768, 1594166702, 1594166702);
INSERT INTO `p_user_room_table` VALUES (276350, 'null', '150602', 1, 5, 1, 0, 10, 8, 1594120907, 1594166702, 1594166702);
INSERT INTO `p_user_room_table` VALUES (276351, 'null', '150602', 100, 5, 1, 0, 10, 8, 1594121151, 1594166702, 1594166702);
INSERT INTO `p_user_room_table` VALUES (276352, '348498', '150603', 1, 2, 1, 0, 20, 4, 1594121156, 1594166702, 1594166702);
INSERT INTO `p_user_room_table` VALUES (276353, 'null', '150602', 10000, 5, 1, 0, 10, 8, 1594121357, 1594166702, 1594166702);
INSERT INTO `p_user_room_table` VALUES (276354, '348509', '150600', 1, 2, 1, 0, 1, 4, 1594190132, 1594253102, 1594253102);
INSERT INTO `p_user_room_table` VALUES (276355, '348509', '150600', 1, 2, 1, 0, 1, 4, 1594190247, 1594253102, 1594253102);
INSERT INTO `p_user_room_table` VALUES (276356, '348509', '150600', 1, 5, 1, 0, 1, 4, 1594257997, 1594339502, 1594339502);
INSERT INTO `p_user_room_table` VALUES (276357, '348510', '150603', 1, 4, 1, 0, 1, 8, 1594280398, 1594339502, 1594339502);
INSERT INTO `p_user_room_table` VALUES (276358, '348511', '150603', 1, 3, 1, 0, 1, 4, 1594280428, 1594288970, 1594288970);
INSERT INTO `p_user_room_table` VALUES (276359, '348512', '150607', 1, 2, 1, 0, 1, 4, 1594280535, 1594339502, 1594339502);
INSERT INTO `p_user_room_table` VALUES (276360, '348513', '150607', 1, 2, 1, 0, 1, 64, 1594281009, 1594339502, 1594339502);
INSERT INTO `p_user_room_table` VALUES (276361, '348509', '150604', 1, 5, 1, 0, 1, 4, 1594346314, 1594346695, 1594346695);
INSERT INTO `p_user_room_table` VALUES (276362, '348509', '150604', 1, 5, 1, 0, 1, 8, 1594346861, 1594347312, 1594347312);
INSERT INTO `p_user_room_table` VALUES (276363, '348509', '150600', 1, 5, 1, 0, 1, 8, 1594347357, 1594347656, 1594347656);
INSERT INTO `p_user_room_table` VALUES (276364, '348509', '150600', 1, 5, 1, 0, 1, 8, 1594347693, 1594347820, 1594347820);
INSERT INTO `p_user_room_table` VALUES (276365, '348509', '150604', 1, 5, 1, 0, 1, 4, 1594347937, 1594349380, 1594349380);
INSERT INTO `p_user_room_table` VALUES (276366, '348510', '150600', 1, 5, 1, 0, 1, 4, 1594348034, 1594348215, 1594348215);
INSERT INTO `p_user_room_table` VALUES (276367, '348510', '150600', 1, 5, 1, 0, 1, 8, 1594348253, 1594360516, 1594360516);
INSERT INTO `p_user_room_table` VALUES (276368, '348513', '150604', 1, 4, 1, 0, 1, 4, 1594358158, 1594425902, 1594425902);
INSERT INTO `p_user_room_table` VALUES (276369, '348512', '150604', 1, 3, 1, 0, 1, 32, 1594358192, 1594425902, 1594425902);
INSERT INTO `p_user_room_table` VALUES (276370, '348511', '150600', 1, 2, 1, 0, 1, 64, 1594358375, 1594425902, 1594425902);
INSERT INTO `p_user_room_table` VALUES (276371, '348511', '150604', 1, 2, 1, 0, 1, 8, 1594374949, 1594425902, 1594425902);
INSERT INTO `p_user_room_table` VALUES (276372, '348509', '150601', 1, 3, 1, 0, 2, 4, 1594376837, 1594425902, 1594425902);
INSERT INTO `p_user_room_table` VALUES (276373, '348509', '150601', 1, 5, 1, 0, 1, 64, 1594460981, 1594512302, 1594512302);
INSERT INTO `p_user_room_table` VALUES (276374, '348510', '150601', 1, 4, 1, 0, 1, 32, 1594461011, 1594512302, 1594512302);
INSERT INTO `p_user_room_table` VALUES (276375, '348511', '150604', 1, 2, 1, 0, 1, 4, 1594618332, 1594685102, 1594685102);
INSERT INTO `p_user_room_table` VALUES (276376, '348509', '150600', 1, 3, 1, 0, 1, 8, 1594618503, 1594685102, 1594685102);
INSERT INTO `p_user_room_table` VALUES (276377, '348510', '150601', 1, 4, 1, 0, 1, 32, 1594627031, 1594685102, 1594685102);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
